Dataset statistics
| Number of variables | 34 |
|---|---|
| Number of observations | 21593 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.6 MiB |
| Average record size in memory | 272.0 B |
Variable types
| NUM | 25 |
|---|---|
| BOOL | 7 |
| CAT | 2 |
Reproduction
| Analysis started | 2020-08-07 01:40:12.608099 |
|---|---|
| Analysis finished | 2020-08-07 01:41:38.665380 |
| Duration | 1 minute and 26.06 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
date has a high cardinality: 372 distinct values | High cardinality |
log_sqft_living is highly correlated with sqft_living | High correlation |
sqft_living is highly correlated with log_sqft_living | High correlation |
log_sqft_above is highly correlated with sqft_above | High correlation |
sqft_above is highly correlated with log_sqft_above | High correlation |
log_sqft_living15 is highly correlated with sqft_living15 | High correlation |
sqft_living15 is highly correlated with log_sqft_living15 | High correlation |
log_sqft_lot15 is highly correlated with log_sqft_lot | High correlation |
log_sqft_lot is highly correlated with log_sqft_lot15 | High correlation |
Unnamed: 0 has unique values | Unique |
view has 19481 (90.2%) zeros | Zeros |
sqft_basement has 13278 (61.5%) zeros | Zeros |
yr_renovated has 20849 (96.6%) zeros | Zeros |
| Distinct count | 21593 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10798.316259899042 |
|---|---|
| Minimum | 0 |
| Maximum | 21596 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1079.6 |
| Q1 | 5399 |
| median | 10798 |
| Q3 | 16198 |
| 95-th percentile | 20516.4 |
| Maximum | 21596 |
| Range | 21596 |
| Interquartile range (IQR) | 10799 |
Descriptive statistics
| Standard deviation | 6234.95893 |
|---|---|
| Coefficient of variation (CV) | 0.5774010299 |
| Kurtosis | -1.200173433 |
| Mean | 10798.31626 |
| Median Absolute Deviation (MAD) | 5400 |
| Skewness | -3.367561324e-05 |
| Sum | 233168043 |
| Variance | 38874712.86 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 10896 | 1 | < 0.1% | |
| 12931 | 1 | < 0.1% | |
| 2692 | 1 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 6790 | 1 | < 0.1% | |
| 4743 | 1 | < 0.1% | |
| 19084 | 1 | < 0.1% | |
| 17037 | 1 | < 0.1% | |
| 21135 | 1 | < 0.1% | |
| Other values (21583) | 21583 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 21596 | 1 | < 0.1% | |
| 21595 | 1 | < 0.1% | |
| 21594 | 1 | < 0.1% | |
| 21593 | 1 | < 0.1% | |
| 21592 | 1 | < 0.1% |
id
Real number (ℝ≥0)
| Distinct count | 21416 |
|---|---|
| Unique (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4580300249.665308 |
|---|---|
| Minimum | 1000102 |
| Maximum | 9900000190 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 512480335 |
| Q1 | 2123049142 |
| median | 3904930240 |
| Q3 | 7308900490 |
| 95-th percentile | 9297300429 |
| Maximum | 9900000190 |
| Range | 9899000088 |
| Interquartile range (IQR) | 5185851348 |
Descriptive statistics
| Standard deviation | 2876833103 |
|---|---|
| Coefficient of variation (CV) | 0.6280883231 |
| Kurtosis | -1.260728428 |
| Mean | 4580300250 |
| Median Absolute Deviation (MAD) | 2402530100 |
| Skewness | 0.243326476 |
| Sum | 9.890242329e+13 |
| Variance | 8.276168703e+18 |
| Value | Count | Frequency (%) | |
| 795000620 | 3 | < 0.1% | |
| 1825069031 | 2 | < 0.1% | |
| 5101405604 | 2 | < 0.1% | |
| 3578401060 | 2 | < 0.1% | |
| 3332000615 | 2 | < 0.1% | |
| 1036400200 | 2 | < 0.1% | |
| 3395040550 | 2 | < 0.1% | |
| 7387500235 | 2 | < 0.1% | |
| 6117501820 | 2 | < 0.1% | |
| 1232000810 | 2 | < 0.1% | |
| Other values (21406) | 21572 | 99.9% |
| Value | Count | Frequency (%) | |
| 1000102 | 2 | < 0.1% | |
| 1200019 | 1 | < 0.1% | |
| 1200021 | 1 | < 0.1% | |
| 2800031 | 1 | < 0.1% | |
| 3600057 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9900000190 | 1 | < 0.1% | |
| 9895000040 | 1 | < 0.1% | |
| 9842300540 | 1 | < 0.1% | |
| 9842300485 | 1 | < 0.1% | |
| 9842300095 | 1 | < 0.1% |
| Distinct count | 372 |
|---|---|
| Unique (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 2014-06-23 | 142 |
|---|---|
| 2014-06-25 | 131 |
| 2014-06-26 | 131 |
| 2014-07-08 | 127 |
| 2015-04-27 | 126 |
| Other values (367) |
| Value | Count | Frequency (%) | |
| 2014-06-23 | 142 | 0.7% | |
| 2014-06-25 | 131 | 0.6% | |
| 2014-06-26 | 131 | 0.6% | |
| 2014-07-08 | 127 | 0.6% | |
| 2015-04-27 | 126 | 0.6% | |
| 2015-03-25 | 123 | 0.6% | |
| 2015-04-28 | 121 | 0.6% | |
| 2014-07-09 | 121 | 0.6% | |
| 2015-04-14 | 121 | 0.6% | |
| 2015-04-22 | 121 | 0.6% | |
| Other values (362) | 20329 | 94.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
price
Real number (ℝ≥0)
| Distinct count | 3621 |
|---|---|
| Unique (%) | 16.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 540352.6882786088 |
|---|---|
| Minimum | 78000.0 |
| Maximum | 7700000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 78000 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 322000 |
| median | 450000 |
| Q3 | 645000 |
| 95-th percentile | 1160000 |
| Maximum | 7700000 |
| Range | 7622000 |
| Interquartile range (IQR) | 323000 |
Descriptive statistics
| Standard deviation | 367377.5333 |
|---|---|
| Coefficient of variation (CV) | 0.6798847147 |
| Kurtosis | 34.54189159 |
| Mean | 540352.6883 |
| Median Absolute Deviation (MAD) | 150000 |
| Skewness | 4.023468647 |
| Sum | 1.16678356e+10 |
| Variance | 1.34966252e+11 |
| Value | Count | Frequency (%) | |
| 350000 | 172 | 0.8% | |
| 450000 | 172 | 0.8% | |
| 550000 | 159 | 0.7% | |
| 500000 | 152 | 0.7% | |
| 425000 | 150 | 0.7% | |
| 325000 | 148 | 0.7% | |
| 400000 | 145 | 0.7% | |
| 375000 | 138 | 0.6% | |
| 300000 | 133 | 0.6% | |
| 525000 | 131 | 0.6% | |
| Other values (3611) | 20093 | 93.1% |
| Value | Count | Frequency (%) | |
| 78000 | 1 | < 0.1% | |
| 80000 | 1 | < 0.1% | |
| 81000 | 1 | < 0.1% | |
| 82000 | 1 | < 0.1% | |
| 82500 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7700000 | 1 | < 0.1% | |
| 7060000 | 1 | < 0.1% | |
| 6890000 | 1 | < 0.1% | |
| 5570000 | 1 | < 0.1% | |
| 5350000 | 1 | < 0.1% |
bedrooms
Real number (ℝ≥0)
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.372018709767054 |
|---|---|
| Minimum | 1 |
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9039294469 |
|---|---|
| Coefficient of variation (CV) | 0.2680677436 |
| Kurtosis | 1.798900302 |
| Mean | 3.37201871 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.5523050281 |
| Sum | 72812 |
| Variance | 0.817088445 |
| Value | Count | Frequency (%) | |
| 3 | 9825 | 45.5% | |
| 4 | 6881 | 31.9% | |
| 2 | 2758 | 12.8% | |
| 5 | 1601 | 7.4% | |
| 6 | 272 | 1.3% | |
| 1 | 195 | 0.9% | |
| 7 | 38 | 0.2% | |
| 8 | 13 | 0.1% | |
| 9 | 6 | < 0.1% | |
| 10 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 195 | 0.9% | |
| 2 | 2758 | 12.8% | |
| 3 | 9825 | 45.5% | |
| 4 | 6881 | 31.9% | |
| 5 | 1601 | 7.4% |
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 6 | < 0.1% | |
| 8 | 13 | 0.1% | |
| 7 | 38 | 0.2% |
bathrooms
Real number (ℝ≥0)
| Distinct count | 28 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1161255962580467 |
|---|---|
| Minimum | 0.75 |
| Maximum | 8.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 0.75 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 7.25 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.768740937 |
|---|---|
| Coefficient of variation (CV) | 0.363277557 |
| Kurtosis | 1.28110192 |
| Mean | 2.116125596 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.5208516589 |
| Sum | 45693.5 |
| Variance | 0.5909626282 |
| Value | Count | Frequency (%) | |
| 2.5 | 5377 | 24.9% | |
| 1 | 3851 | 17.8% | |
| 1.75 | 3048 | 14.1% | |
| 2.25 | 2047 | 9.5% | |
| 2 | 1930 | 8.9% | |
| 1.5 | 1445 | 6.7% | |
| 2.75 | 1185 | 5.5% | |
| 3 | 753 | 3.5% | |
| 3.5 | 731 | 3.4% | |
| 3.25 | 589 | 2.7% | |
| Other values (18) | 637 | 3.0% |
| Value | Count | Frequency (%) | |
| 0.75 | 71 | 0.3% | |
| 1 | 3851 | 17.8% | |
| 1.25 | 9 | < 0.1% | |
| 1.5 | 1445 | 6.7% | |
| 1.75 | 3048 | 14.1% |
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7.75 | 1 | < 0.1% | |
| 7.5 | 1 | < 0.1% | |
| 6.75 | 2 | < 0.1% | |
| 6.5 | 2 | < 0.1% |
| Distinct count | 1034 |
|---|---|
| Unique (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2080.4784420877136 |
|---|---|
| Minimum | 370 |
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1430 |
| median | 1910 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13170 |
| Interquartile range (IQR) | 1120 |
Descriptive statistics
| Standard deviation | 918.0763767 |
|---|---|
| Coefficient of variation (CV) | 0.4412813698 |
| Kurtosis | 5.253186564 |
| Mean | 2080.478442 |
| Median Absolute Deviation (MAD) | 540 |
| Skewness | 1.473468606 |
| Sum | 44923771 |
| Variance | 842864.2334 |
| Value | Count | Frequency (%) | |
| 1300 | 138 | 0.6% | |
| 1400 | 135 | 0.6% | |
| 1440 | 133 | 0.6% | |
| 1660 | 129 | 0.6% | |
| 1010 | 129 | 0.6% | |
| 1800 | 129 | 0.6% | |
| 1820 | 128 | 0.6% | |
| 1480 | 125 | 0.6% | |
| 1720 | 125 | 0.6% | |
| 1540 | 124 | 0.6% | |
| Other values (1024) | 20298 | 94.0% |
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13540 | 1 | < 0.1% | |
| 12050 | 1 | < 0.1% | |
| 10040 | 1 | < 0.1% | |
| 9890 | 1 | < 0.1% | |
| 9640 | 1 | < 0.1% |
sqft_lot
Real number (ℝ≥0)
| Distinct count | 9775 |
|---|---|
| Unique (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15101.193396007966 |
|---|---|
| Minimum | 520 |
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1802.2 |
| Q1 | 5040 |
| median | 7620 |
| Q3 | 10687 |
| 95-th percentile | 43313.4 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5647 |
Descriptive statistics
| Standard deviation | 41416.25276 |
|---|---|
| Coefficient of variation (CV) | 2.742581442 |
| Kurtosis | 285.4462622 |
| Mean | 15101.1934 |
| Median Absolute Deviation (MAD) | 2620 |
| Skewness | 13.07147474 |
| Sum | 326080069 |
| Variance | 1715305993 |
| Value | Count | Frequency (%) | |
| 5000 | 358 | 1.7% | |
| 6000 | 290 | 1.3% | |
| 4000 | 251 | 1.2% | |
| 7200 | 220 | 1.0% | |
| 7500 | 119 | 0.6% | |
| 4800 | 119 | 0.6% | |
| 4500 | 114 | 0.5% | |
| 8400 | 111 | 0.5% | |
| 9600 | 109 | 0.5% | |
| 3600 | 103 | 0.5% | |
| Other values (9765) | 19799 | 91.7% |
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 572 | 1 | < 0.1% | |
| 600 | 1 | < 0.1% | |
| 609 | 1 | < 0.1% | |
| 635 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1651359 | 1 | < 0.1% | |
| 1164794 | 1 | < 0.1% | |
| 1074218 | 1 | < 0.1% | |
| 1024068 | 1 | < 0.1% | |
| 982998 | 1 | < 0.1% |
floors
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4941416199694346 |
|---|---|
| Minimum | 1.0 |
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5396903708 |
|---|---|
| Coefficient of variation (CV) | 0.3612042952 |
| Kurtosis | -0.4910812338 |
| Mean | 1.49414162 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.6144020272 |
| Sum | 32263 |
| Variance | 0.2912656963 |
| Value | Count | Frequency (%) | |
| 1 | 10670 | 49.4% | |
| 2 | 8234 | 38.1% | |
| 1.5 | 1910 | 8.8% | |
| 3 | 611 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 10670 | 49.4% | |
| 1.5 | 1910 | 8.8% | |
| 2 | 8234 | 38.1% | |
| 2.5 | 161 | 0.7% | |
| 3 | 611 | 2.8% |
| Value | Count | Frequency (%) | |
| 3.5 | 7 | < 0.1% | |
| 3 | 611 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 2 | 8234 | 38.1% | |
| 1.5 | 1910 | 8.8% |
waterfront
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 | 146 |
| Value | Count | Frequency (%) | |
| 0 | 21447 | 99.3% | |
| 1 | 146 | 0.7% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.23322372991247164 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4.0 |
| Zeros | 19481 |
| Zeros (%) | 90.2% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7647368185 |
|---|---|
| Coefficient of variation (CV) | 3.278983742 |
| Kurtosis | 10.96213403 |
| Mean | 0.2332237299 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.405306519 |
| Sum | 5036 |
| Variance | 0.5848224016 |
| Value | Count | Frequency (%) | |
| 0 | 19481 | 90.2% | |
| 2 | 957 | 4.4% | |
| 3 | 508 | 2.4% | |
| 1 | 330 | 1.5% | |
| 4 | 317 | 1.5% |
| Value | Count | Frequency (%) | |
| 0 | 19481 | 90.2% | |
| 1 | 330 | 1.5% | |
| 2 | 957 | 4.4% | |
| 3 | 508 | 2.4% | |
| 4 | 317 | 1.5% |
| Value | Count | Frequency (%) | |
| 4 | 317 | 1.5% | |
| 3 | 508 | 2.4% | |
| 2 | 957 | 4.4% | |
| 1 | 330 | 1.5% | |
| 0 | 19481 | 90.2% |
condition
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.409855045616635 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.6505755584 |
|---|---|
| Coefficient of variation (CV) | 0.1907927316 |
| Kurtosis | 0.5190001303 |
| Mean | 3.409855046 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.035950016 |
| Sum | 73629 |
| Variance | 0.4232485572 |
| Value | Count | Frequency (%) | |
| 3 | 14017 | 64.9% | |
| 4 | 5676 | 26.3% | |
| 5 | 1701 | 7.9% | |
| 2 | 170 | 0.8% | |
| 1 | 29 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 29 | 0.1% | |
| 2 | 170 | 0.8% | |
| 3 | 14017 | 64.9% | |
| 4 | 5676 | 26.3% | |
| 5 | 1701 | 7.9% |
| Value | Count | Frequency (%) | |
| 5 | 1701 | 7.9% | |
| 4 | 5676 | 26.3% | |
| 3 | 14017 | 64.9% | |
| 2 | 170 | 0.8% | |
| 1 | 29 | 0.1% |
grade
Real number (ℝ≥0)
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.658176260825267 |
|---|---|
| Minimum | 3 |
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.173058039 |
|---|---|
| Coefficient of variation (CV) | 0.1531772055 |
| Kurtosis | 1.135619244 |
| Mean | 7.658176261 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.7888003482 |
| Sum | 165363 |
| Variance | 1.376065162 |
| Value | Count | Frequency (%) | |
| 7 | 8974 | 41.6% | |
| 8 | 6064 | 28.1% | |
| 9 | 2615 | 12.1% | |
| 6 | 2036 | 9.4% | |
| 10 | 1134 | 5.3% | |
| 11 | 399 | 1.8% | |
| 5 | 241 | 1.1% | |
| 12 | 89 | 0.4% | |
| 4 | 27 | 0.1% | |
| 13 | 13 | 0.1% |
| Value | Count | Frequency (%) | |
| 3 | 1 | < 0.1% | |
| 4 | 27 | 0.1% | |
| 5 | 241 | 1.1% | |
| 6 | 2036 | 9.4% | |
| 7 | 8974 | 41.6% |
| Value | Count | Frequency (%) | |
| 13 | 13 | 0.1% | |
| 12 | 89 | 0.4% | |
| 11 | 399 | 1.8% | |
| 10 | 1134 | 5.3% | |
| 9 | 2615 | 12.1% |
| Distinct count | 942 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1788.7443152873616 |
|---|---|
| Minimum | 370 |
| Maximum | 9410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1190 |
| median | 1560 |
| Q3 | 2210 |
| 95-th percentile | 3400 |
| Maximum | 9410 |
| Range | 9040 |
| Interquartile range (IQR) | 1020 |
Descriptive statistics
| Standard deviation | 827.7015965 |
|---|---|
| Coefficient of variation (CV) | 0.46272773 |
| Kurtosis | 3.406782397 |
| Mean | 1788.744315 |
| Median Absolute Deviation (MAD) | 450 |
| Skewness | 1.447921763 |
| Sum | 38624356 |
| Variance | 685089.9328 |
| Value | Count | Frequency (%) | |
| 1300 | 212 | 1.0% | |
| 1010 | 210 | 1.0% | |
| 1200 | 206 | 1.0% | |
| 1220 | 192 | 0.9% | |
| 1140 | 184 | 0.9% | |
| 1400 | 180 | 0.8% | |
| 1060 | 178 | 0.8% | |
| 1180 | 177 | 0.8% | |
| 1340 | 176 | 0.8% | |
| 1250 | 174 | 0.8% | |
| Other values (932) | 19704 | 91.3% |
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9410 | 1 | < 0.1% | |
| 8860 | 1 | < 0.1% | |
| 8570 | 1 | < 0.1% | |
| 8020 | 1 | < 0.1% | |
| 7880 | 1 | < 0.1% |
| Distinct count | 303 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 285.7245866716065 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4820.0 |
| Zeros | 13278 |
| Zeros (%) | 61.5% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 550 |
| 95-th percentile | 1180 |
| Maximum | 4820 |
| Range | 4820 |
| Interquartile range (IQR) | 550 |
Descriptive statistics
| Standard deviation | 439.8466289 |
|---|---|
| Coefficient of variation (CV) | 1.5394077 |
| Kurtosis | 2.813145198 |
| Mean | 285.7245867 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.60523078 |
| Sum | 6169651 |
| Variance | 193465.0569 |
| Value | Count | Frequency (%) | |
| 0 | 13278 | 61.5% | |
| 600 | 217 | 1.0% | |
| 500 | 209 | 1.0% | |
| 700 | 208 | 1.0% | |
| 800 | 201 | 0.9% | |
| 400 | 184 | 0.9% | |
| 1000 | 148 | 0.7% | |
| 900 | 142 | 0.7% | |
| 300 | 142 | 0.7% | |
| 200 | 105 | 0.5% | |
| Other values (293) | 6759 | 31.3% |
| Value | Count | Frequency (%) | |
| 0 | 13278 | 61.5% | |
| 10 | 2 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 40 | 4 | < 0.1% | |
| 50 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 4820 | 1 | < 0.1% | |
| 4130 | 1 | < 0.1% | |
| 3500 | 1 | < 0.1% | |
| 3480 | 1 | < 0.1% | |
| 3260 | 1 | < 0.1% |
yr_built
Real number (ℝ≥0)
| Distinct count | 116 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1971.0039364608901 |
|---|---|
| Minimum | 1900 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1951 |
| median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 29.37328638 |
|---|---|
| Coefficient of variation (CV) | 0.01490270305 |
| Kurtosis | -0.6573312361 |
| Mean | 1971.003936 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.4695978121 |
| Sum | 42559888 |
| Variance | 862.789953 |
| Value | Count | Frequency (%) | |
| 2014 | 559 | 2.6% | |
| 2006 | 453 | 2.1% | |
| 2005 | 450 | 2.1% | |
| 2004 | 433 | 2.0% | |
| 2003 | 420 | 1.9% | |
| 2007 | 417 | 1.9% | |
| 1977 | 417 | 1.9% | |
| 1978 | 387 | 1.8% | |
| 1968 | 381 | 1.8% | |
| 2008 | 367 | 1.7% | |
| Other values (106) | 17309 | 80.2% |
| Value | Count | Frequency (%) | |
| 1900 | 87 | 0.4% | |
| 1901 | 29 | 0.1% | |
| 1902 | 27 | 0.1% | |
| 1903 | 46 | 0.2% | |
| 1904 | 45 | 0.2% |
| Value | Count | Frequency (%) | |
| 2015 | 38 | 0.2% | |
| 2014 | 559 | 2.6% | |
| 2013 | 201 | 0.9% | |
| 2012 | 170 | 0.8% | |
| 2011 | 130 | 0.6% |
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.77094428750058 |
|---|---|
| Minimum | 0.0 |
| Maximum | 2015.0 |
| Zeros | 20849 |
| Zeros (%) | 96.6% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 364.0700142 |
|---|---|
| Coefficient of variation (CV) | 5.293951071 |
| Kurtosis | 24.0715287 |
| Mean | 68.77094429 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.105627432 |
| Sum | 1484971 |
| Variance | 132546.9752 |
| Value | Count | Frequency (%) | |
| 0 | 20849 | 96.6% | |
| 2014 | 73 | 0.3% | |
| 2003 | 31 | 0.1% | |
| 2013 | 31 | 0.1% | |
| 2007 | 30 | 0.1% | |
| 2000 | 29 | 0.1% | |
| 2005 | 29 | 0.1% | |
| 1990 | 22 | 0.1% | |
| 2004 | 22 | 0.1% | |
| 2009 | 21 | 0.1% | |
| Other values (60) | 456 | 2.1% |
| Value | Count | Frequency (%) | |
| 0 | 20849 | 96.6% | |
| 1934 | 1 | < 0.1% | |
| 1940 | 2 | < 0.1% | |
| 1944 | 1 | < 0.1% | |
| 1945 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2015 | 14 | 0.1% | |
| 2014 | 73 | 0.3% | |
| 2013 | 31 | 0.1% | |
| 2012 | 8 | < 0.1% | |
| 2011 | 9 | < 0.1% |
zipcode
Real number (ℝ≥0)
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98077.9435465197 |
|---|---|
| Minimum | 98001 |
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| median | 98065 |
| Q3 | 98118 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 53.51368114 |
|---|---|
| Coefficient of variation (CV) | 0.000545624013 |
| Kurtosis | -0.8536972882 |
| Mean | 98077.94355 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 0.4056566995 |
| Sum | 2117797035 |
| Variance | 2863.714069 |
| Value | Count | Frequency (%) | |
| 98103 | 602 | 2.8% | |
| 98038 | 589 | 2.7% | |
| 98115 | 583 | 2.7% | |
| 98052 | 574 | 2.7% | |
| 98117 | 553 | 2.6% | |
| 98042 | 547 | 2.5% | |
| 98034 | 545 | 2.5% | |
| 98118 | 506 | 2.3% | |
| 98023 | 499 | 2.3% | |
| 98006 | 498 | 2.3% | |
| Other values (60) | 16097 | 74.5% |
| Value | Count | Frequency (%) | |
| 98001 | 361 | 1.7% | |
| 98002 | 199 | 0.9% | |
| 98003 | 280 | 1.3% | |
| 98004 | 317 | 1.5% | |
| 98005 | 168 | 0.8% |
| Value | Count | Frequency (%) | |
| 98199 | 317 | 1.5% | |
| 98198 | 280 | 1.3% | |
| 98188 | 136 | 0.6% | |
| 98178 | 262 | 1.2% | |
| 98177 | 255 | 1.2% |
lat
Real number (ℝ≥0)
| Distinct count | 5033 |
|---|---|
| Unique (%) | 23.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.560095595794934 |
|---|---|
| Minimum | 47.1559 |
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.4711 |
| median | 47.5718 |
| Q3 | 47.678 |
| 95-th percentile | 47.74964 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.2069 |
Descriptive statistics
| Standard deviation | 0.1385479518 |
|---|---|
| Coefficient of variation (CV) | 0.0029131134 |
| Kurtosis | -0.6756685961 |
| Mean | 47.5600956 |
| Median Absolute Deviation (MAD) | 0.1049 |
| Skewness | -0.4856487353 |
| Sum | 1026965.144 |
| Variance | 0.01919553495 |
| Value | Count | Frequency (%) | |
| 47.6624 | 17 | 0.1% | |
| 47.5322 | 17 | 0.1% | |
| 47.6846 | 17 | 0.1% | |
| 47.5491 | 17 | 0.1% | |
| 47.6886 | 16 | 0.1% | |
| 47.6955 | 16 | 0.1% | |
| 47.6711 | 16 | 0.1% | |
| 47.5402 | 15 | 0.1% | |
| 47.686 | 15 | 0.1% | |
| 47.6842 | 15 | 0.1% | |
| Other values (5023) | 21432 | 99.3% |
| Value | Count | Frequency (%) | |
| 47.1559 | 1 | < 0.1% | |
| 47.1593 | 1 | < 0.1% | |
| 47.1622 | 1 | < 0.1% | |
| 47.1647 | 1 | < 0.1% | |
| 47.1764 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 47.7776 | 3 | < 0.1% | |
| 47.7775 | 3 | < 0.1% | |
| 47.7774 | 1 | < 0.1% | |
| 47.7772 | 3 | < 0.1% | |
| 47.7771 | 2 | < 0.1% |
long
Real number (ℝ)
| Distinct count | 751 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.21397036076507 |
|---|---|
| Minimum | -122.519 |
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.231 |
| Q3 | -122.125 |
| 95-th percentile | -121.9796 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.1407300141 |
|---|---|
| Coefficient of variation (CV) | -0.001151505132 |
| Kurtosis | 1.051731193 |
| Mean | -122.2139704 |
| Median Absolute Deviation (MAD) | 0.101 |
| Skewness | 0.8847546201 |
| Sum | -2638966.262 |
| Variance | 0.01980493688 |
| Value | Count | Frequency (%) | |
| -122.29 | 115 | 0.5% | |
| -122.3 | 111 | 0.5% | |
| -122.362 | 104 | 0.5% | |
| -122.291 | 100 | 0.5% | |
| -122.363 | 99 | 0.5% | |
| -122.372 | 98 | 0.5% | |
| -122.288 | 98 | 0.5% | |
| -122.357 | 96 | 0.4% | |
| -122.284 | 95 | 0.4% | |
| -122.365 | 94 | 0.4% | |
| Other values (741) | 20583 | 95.3% |
| Value | Count | Frequency (%) | |
| -122.519 | 1 | < 0.1% | |
| -122.515 | 1 | < 0.1% | |
| -122.514 | 1 | < 0.1% | |
| -122.512 | 1 | < 0.1% | |
| -122.511 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| -121.315 | 2 | < 0.1% | |
| -121.316 | 1 | < 0.1% | |
| -121.319 | 1 | < 0.1% | |
| -121.321 | 1 | < 0.1% | |
| -121.325 | 1 | < 0.1% |
| Distinct count | 777 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1986.7021256888806 |
|---|---|
| Minimum | 399 |
| Maximum | 6210 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| median | 1840 |
| Q3 | 2360 |
| 95-th percentile | 3300 |
| Maximum | 6210 |
| Range | 5811 |
| Interquartile range (IQR) | 870 |
Descriptive statistics
| Standard deviation | 685.263461 |
|---|---|
| Coefficient of variation (CV) | 0.3449251159 |
| Kurtosis | 1.591112486 |
| Mean | 1986.702126 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 1.106633212 |
| Sum | 42898859 |
| Variance | 469586.011 |
| Value | Count | Frequency (%) | |
| 1540 | 197 | 0.9% | |
| 1440 | 195 | 0.9% | |
| 1560 | 192 | 0.9% | |
| 1500 | 180 | 0.8% | |
| 1460 | 169 | 0.8% | |
| 1580 | 167 | 0.8% | |
| 1610 | 166 | 0.8% | |
| 1800 | 166 | 0.8% | |
| 1720 | 166 | 0.8% | |
| 1620 | 164 | 0.8% | |
| Other values (767) | 19831 | 91.8% |
| Value | Count | Frequency (%) | |
| 399 | 1 | < 0.1% | |
| 460 | 2 | < 0.1% | |
| 620 | 2 | < 0.1% | |
| 670 | 1 | < 0.1% | |
| 690 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6210 | 1 | < 0.1% | |
| 6110 | 1 | < 0.1% | |
| 5790 | 6 | < 0.1% | |
| 5610 | 1 | < 0.1% | |
| 5600 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ≥0)
| Distinct count | 8682 |
|---|---|
| Unique (%) | 40.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12759.564210623814 |
|---|---|
| Minimum | 651 |
| Maximum | 871200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 2001.8 |
| Q1 | 5100 |
| median | 7620 |
| Q3 | 10083 |
| 95-th percentile | 37048.4 |
| Maximum | 871200 |
| Range | 870549 |
| Interquartile range (IQR) | 4983 |
Descriptive statistics
| Standard deviation | 27276.78982 |
|---|---|
| Coefficient of variation (CV) | 2.137752463 |
| Kurtosis | 151.3693206 |
| Mean | 12759.56421 |
| Median Absolute Deviation (MAD) | 2505 |
| Skewness | 9.52352988 |
| Sum | 275517270 |
| Variance | 744023263.1 |
| Value | Count | Frequency (%) | |
| 5000 | 427 | 2.0% | |
| 4000 | 356 | 1.6% | |
| 6000 | 288 | 1.3% | |
| 7200 | 210 | 1.0% | |
| 4800 | 145 | 0.7% | |
| 7500 | 142 | 0.7% | |
| 8400 | 116 | 0.5% | |
| 3600 | 111 | 0.5% | |
| 4500 | 111 | 0.5% | |
| 5100 | 109 | 0.5% | |
| Other values (8672) | 19578 | 90.7% |
| Value | Count | Frequency (%) | |
| 651 | 1 | < 0.1% | |
| 659 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% | |
| 748 | 2 | < 0.1% | |
| 750 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 871200 | 1 | < 0.1% | |
| 858132 | 1 | < 0.1% | |
| 560617 | 1 | < 0.1% | |
| 438213 | 1 | < 0.1% | |
| 434728 | 1 | < 0.1% |
city
Categorical
| Distinct count | 24 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| Seattle | |
|---|---|
| Renton | 1597 |
| Bellevue | 1407 |
| Kent | 1201 |
| Redmond | 977 |
| Other values (19) |
| Value | Count | Frequency (%) | |
| Seattle | 8970 | 41.5% | |
| Renton | 1597 | 7.4% | |
| Bellevue | 1407 | 6.5% | |
| Kent | 1201 | 5.6% | |
| Redmond | 977 | 4.5% | |
| Kirkland | 977 | 4.5% | |
| Auburn | 910 | 4.2% | |
| Sammamish | 800 | 3.7% | |
| Federal Way | 779 | 3.6% | |
| Issaquah | 733 | 3.4% | |
| Other values (14) | 3242 | 15.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 7.496086695 |
| Min length | 4 |
livable
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 1 | |
|---|---|
| 0 | 439 |
| Value | Count | Frequency (%) | |
| 1 | 21154 | 98.0% | |
| 0 | 439 | 2.0% |
q2_2014
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 17647 | 81.7% | |
| 1 | 3946 | 18.3% |
q3_2014
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 15673 | 72.6% | |
| 1 | 5920 | 27.4% |
q4_2014
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 16840 | 78.0% | |
| 1 | 4753 | 22.0% |
q1_2015
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 17494 | 81.0% | |
| 1 | 4099 | 19.0% |
q2_2015
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.7 KiB |
| 0 | |
|---|---|
| 1 | 2875 |
| Value | Count | Frequency (%) | |
| 0 | 18718 | 86.7% | |
| 1 | 2875 | 13.3% |
| Distinct count | 1034 |
|---|---|
| Unique (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.550824448748599 |
|---|---|
| Minimum | 5.913503005638269 |
| Maximum | 9.513403546466266 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 5.913503006 |
|---|---|
| 5-th percentile | 6.845879875 |
| Q1 | 7.265429723 |
| median | 7.554858521 |
| Q3 | 7.843848638 |
| 95-th percentile | 8.232174236 |
| Maximum | 9.513403546 |
| Range | 3.599900541 |
| Interquartile range (IQR) | 0.5784189149 |
Descriptive statistics
| Standard deviation | 0.4241064267 |
|---|---|
| Coefficient of variation (CV) | 0.05616690331 |
| Kurtosis | -0.07957048867 |
| Mean | 7.550824449 |
| Median Absolute Deviation (MAD) | 0.2894287978 |
| Skewness | -0.02676200026 |
| Sum | 163044.9523 |
| Variance | 0.1798662612 |
| Value | Count | Frequency (%) | |
| 7.170119543 | 138 | 0.6% | |
| 7.244227516 | 135 | 0.6% | |
| 7.272398393 | 133 | 0.6% | |
| 7.414572881 | 129 | 0.6% | |
| 7.495541944 | 129 | 0.6% | |
| 6.91770561 | 129 | 0.6% | |
| 7.50659178 | 128 | 0.6% | |
| 7.45007957 | 125 | 0.6% | |
| 7.299797367 | 125 | 0.6% | |
| 7.3524411 | 124 | 0.6% | |
| Other values (1024) | 20298 | 94.0% |
| Value | Count | Frequency (%) | |
| 5.913503006 | 1 | < 0.1% | |
| 5.940171253 | 1 | < 0.1% | |
| 5.966146739 | 1 | < 0.1% | |
| 6.01615716 | 1 | < 0.1% | |
| 6.040254711 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.513403546 | 1 | < 0.1% | |
| 9.396819939 | 1 | < 0.1% | |
| 9.214332393 | 1 | < 0.1% | |
| 9.199279425 | 1 | < 0.1% | |
| 9.173676388 | 1 | < 0.1% |
| Distinct count | 9775 |
|---|---|
| Unique (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.989903616131151 |
|---|---|
| Minimum | 6.253828811575472 |
| Maximum | 14.317109143238099 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 6.253828812 |
|---|---|
| 5-th percentile | 7.496763272 |
| Q1 | 8.525161361 |
| median | 8.938531649 |
| Q3 | 9.276783329 |
| 95-th percentile | 10.67621727 |
| Maximum | 14.31710914 |
| Range | 8.063280332 |
| Interquartile range (IQR) | 0.7516219675 |
Descriptive statistics
| Standard deviation | 0.9020928296 |
|---|---|
| Coefficient of variation (CV) | 0.1003451058 |
| Kurtosis | 3.329909965 |
| Mean | 8.989903616 |
| Median Absolute Deviation (MAD) | 0.3821177441 |
| Skewness | 0.9625569696 |
| Sum | 194118.9888 |
| Variance | 0.8137714732 |
| Value | Count | Frequency (%) | |
| 8.517193191 | 358 | 1.7% | |
| 8.699514748 | 290 | 1.3% | |
| 8.29404964 | 251 | 1.2% | |
| 8.881836305 | 220 | 1.0% | |
| 8.9226583 | 119 | 0.6% | |
| 8.476371197 | 119 | 0.6% | |
| 8.411832676 | 114 | 0.5% | |
| 9.035986985 | 111 | 0.5% | |
| 9.169518377 | 109 | 0.5% | |
| 8.188689124 | 103 | 0.5% | |
| Other values (9765) | 19799 | 91.7% |
| Value | Count | Frequency (%) | |
| 6.253828812 | 1 | < 0.1% | |
| 6.349138991 | 1 | < 0.1% | |
| 6.396929655 | 1 | < 0.1% | |
| 6.411818268 | 1 | < 0.1% | |
| 6.453624999 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14.31710914 | 1 | < 0.1% | |
| 13.96805481 | 1 | < 0.1% | |
| 13.88710351 | 1 | < 0.1% | |
| 13.83929349 | 1 | < 0.1% | |
| 13.79836236 | 1 | < 0.1% |
| Distinct count | 942 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.395281436695742 |
|---|---|
| Minimum | 5.913503005638269 |
| Maximum | 9.149528232579426 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 5.913503006 |
|---|---|
| 5-th percentile | 6.745236349 |
| Q1 | 7.081708586 |
| median | 7.3524411 |
| Q3 | 7.700747795 |
| 95-th percentile | 8.131530711 |
| Maximum | 9.149528233 |
| Range | 3.236025227 |
| Interquartile range (IQR) | 0.6190392084 |
Descriptive statistics
| Standard deviation | 0.4269842563 |
|---|---|
| Coefficient of variation (CV) | 0.05773739106 |
| Kurtosis | -0.335656595 |
| Mean | 7.395281437 |
| Median Absolute Deviation (MAD) | 0.3049238789 |
| Skewness | 0.2613249619 |
| Sum | 159686.3121 |
| Variance | 0.1823155552 |
| Value | Count | Frequency (%) | |
| 7.170119543 | 212 | 1.0% | |
| 6.91770561 | 210 | 1.0% | |
| 7.090076836 | 206 | 1.0% | |
| 7.106606138 | 192 | 0.9% | |
| 7.038783541 | 184 | 0.9% | |
| 7.244227516 | 180 | 0.8% | |
| 6.966024187 | 178 | 0.8% | |
| 7.073269717 | 177 | 0.8% | |
| 7.200424893 | 176 | 0.8% | |
| 7.13089883 | 174 | 0.8% | |
| Other values (932) | 19704 | 91.3% |
| Value | Count | Frequency (%) | |
| 5.913503006 | 1 | < 0.1% | |
| 5.940171253 | 1 | < 0.1% | |
| 5.966146739 | 1 | < 0.1% | |
| 6.01615716 | 1 | < 0.1% | |
| 6.040254711 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.149528233 | 1 | < 0.1% | |
| 9.089302044 | 1 | < 0.1% | |
| 9.056023012 | 1 | < 0.1% | |
| 8.989693701 | 1 | < 0.1% | |
| 8.972083183 | 1 | < 0.1% |
| Distinct count | 777 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.539531474350569 |
|---|---|
| Minimum | 5.988961416889863 |
| Maximum | 8.733916174927524 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 5.988961417 |
|---|---|
| 5-th percentile | 7.038783541 |
| Q1 | 7.306531399 |
| median | 7.517520851 |
| Q3 | 7.766416898 |
| 95-th percentile | 8.101677747 |
| Maximum | 8.733916175 |
| Range | 2.744954758 |
| Interquartile range (IQR) | 0.4598854991 |
Descriptive statistics
| Standard deviation | 0.3274824895 |
|---|---|
| Coefficient of variation (CV) | 0.04343538994 |
| Kurtosis | -0.2082238891 |
| Mean | 7.539531474 |
| Median Absolute Deviation (MAD) | 0.2313291359 |
| Skewness | 0.2057211577 |
| Sum | 162801.1031 |
| Variance | 0.107244781 |
| Value | Count | Frequency (%) | |
| 7.339537695 | 197 | 0.9% | |
| 7.272398393 | 195 | 0.9% | |
| 7.3524411 | 192 | 0.9% | |
| 7.313220387 | 180 | 0.8% | |
| 7.286191715 | 169 | 0.8% | |
| 7.365180126 | 167 | 0.8% | |
| 7.495541944 | 166 | 0.8% | |
| 7.383989458 | 166 | 0.8% | |
| 7.45007957 | 166 | 0.8% | |
| 7.31986493 | 164 | 0.8% | |
| Other values (767) | 19831 | 91.8% |
| Value | Count | Frequency (%) | |
| 5.988961417 | 1 | < 0.1% | |
| 6.131226489 | 2 | < 0.1% | |
| 6.429719478 | 2 | < 0.1% | |
| 6.507277712 | 1 | < 0.1% | |
| 6.536691598 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8.733916175 | 1 | < 0.1% | |
| 8.717682052 | 1 | < 0.1% | |
| 8.663887571 | 6 | < 0.1% | |
| 8.632305999 | 1 | < 0.1% | |
| 8.630521877 | 1 | < 0.1% |
| Distinct count | 8682 |
|---|---|
| Unique (%) | 40.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.960825422816484 |
|---|---|
| Minimum | 6.478509642208568 |
| Maximum | 13.677626850600886 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.7 KiB |
Quantile statistics
| Minimum | 6.478509642 |
|---|---|
| 5-th percentile | 7.601801785 |
| Q1 | 8.536995819 |
| median | 8.938531649 |
| Q3 | 9.218606116 |
| 95-th percentile | 10.51998042 |
| Maximum | 13.67762685 |
| Range | 7.199117208 |
| Interquartile range (IQR) | 0.6816102977 |
Descriptive statistics
| Standard deviation | 0.8126546153 |
|---|---|
| Coefficient of variation (CV) | 0.09068970513 |
| Kurtosis | 3.563773667 |
| Mean | 8.960825423 |
| Median Absolute Deviation (MAD) | 0.3413347859 |
| Skewness | 0.9660663034 |
| Sum | 193491.1034 |
| Variance | 0.6604075238 |
| Value | Count | Frequency (%) | |
| 8.517193191 | 427 | 2.0% | |
| 8.29404964 | 356 | 1.6% | |
| 8.699514748 | 288 | 1.3% | |
| 8.881836305 | 210 | 1.0% | |
| 8.476371197 | 145 | 0.7% | |
| 8.9226583 | 142 | 0.7% | |
| 9.035986985 | 116 | 0.5% | |
| 8.188689124 | 111 | 0.5% | |
| 8.411832676 | 111 | 0.5% | |
| 8.536995819 | 109 | 0.5% | |
| Other values (8672) | 19578 | 90.7% |
| Value | Count | Frequency (%) | |
| 6.478509642 | 1 | < 0.1% | |
| 6.490723535 | 1 | < 0.1% | |
| 6.492239835 | 1 | < 0.1% | |
| 6.617402978 | 2 | < 0.1% | |
| 6.620073207 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13.67762685 | 1 | < 0.1% | |
| 13.66251321 | 1 | < 0.1% | |
| 13.23679324 | 1 | < 0.1% | |
| 12.99046037 | 1 | < 0.1% | |
| 12.98247583 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Unnamed: 0 | id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | city | livable | q2_2014 | q3_2014 | q4_2014 | q1_2015 | q2_2015 | log_sqft_living | log_sqft_lot | log_sqft_above | log_sqft_living15 | log_sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 7129300520 | 2014-10-13 | 221,900.0 | 3 | 1.0 | 1180 | 5650 | 1.0 | 0.0 | 0.0 | 3 | 7 | 1180 | 0.0 | 1955 | 0.0 | 98178 | 47.5112 | -122.257 | 1340 | 5650 | Seattle | 1 | 0 | 0 | 1 | 0 | 0 | 7.073269717459709 | 8.639410824140487 | 7.073269717459709 | 7.200424892944957 | 8.639410824140487 |
| 1 | 1 | 6414100192 | 2014-12-09 | 538,000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | 0.0 | 0.0 | 3 | 7 | 2170 | 400.0 | 1951 | 1,991.0 | 98125 | 47.721 | -122.319 | 1690 | 7639 | Seattle | 1 | 0 | 0 | 1 | 0 | 0 | 7.851661177889265 | 8.887652690325586 | 7.6824824465345065 | 7.432483807917119 | 8.94102198354136 |
| 2 | 2 | 5631500400 | 2015-02-25 | 180,000.0 | 2 | 1.0 | 770 | 10000 | 1.0 | 0.0 | 0.0 | 3 | 6 | 770 | 0.0 | 1933 | 0.0 | 98028 | 47.7379 | -122.233 | 2720 | 8062 | Kenmore | 1 | 0 | 0 | 0 | 1 | 0 | 6.646390514847728 | 9.210340371976184 | 6.646390514847728 | 7.908387159290043 | 8.994916943677111 |
| 3 | 3 | 2487200875 | 2014-12-09 | 604,000.0 | 4 | 3.0 | 1960 | 5000 | 1.0 | 0.0 | 0.0 | 5 | 7 | 1050 | 910.0 | 1965 | 0.0 | 98136 | 47.5208 | -122.393 | 1360 | 5000 | Seattle | 1 | 0 | 0 | 1 | 0 | 0 | 7.580699752224562 | 8.517193191416238 | 6.956545443151568 | 7.215239978730098 | 8.517193191416238 |
| 4 | 4 | 1954400510 | 2015-02-18 | 510,000.0 | 3 | 2.0 | 1680 | 8080 | 1.0 | 0.0 | 0.0 | 3 | 8 | 1680 | 0.0 | 1987 | 0.0 | 98074 | 47.6168 | -122.045 | 1800 | 7503 | Sammamish | 1 | 0 | 0 | 0 | 1 | 0 | 7.426549072397305 | 8.997147151515144 | 7.426549072397305 | 7.495541943884256 | 8.923058219545727 |
| 5 | 5 | 7237550310 | 2014-05-12 | 1,230,000.0 | 4 | 4.5 | 5420 | 101930 | 1.0 | 0.0 | 0.0 | 3 | 11 | 3890 | 1,530.0 | 2001 | 0.0 | 98053 | 47.6561 | -122.005 | 4760 | 101930 | Redmond | 1 | 1 | 0 | 0 | 0 | 0 | 8.597851094433691 | 11.532041582162456 | 8.266164436612492 | 8.468002947225466 | 11.532041582162456 |
| 6 | 6 | 1321400060 | 2014-06-27 | 257,500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | 0.0 | 0.0 | 3 | 7 | 1715 | 0.0 | 1995 | 0.0 | 98003 | 47.3097 | -122.327 | 2238 | 6819 | Federal Way | 1 | 1 | 0 | 0 | 0 | 0 | 7.44716835960004 | 8.827468112520654 | 7.44716835960004 | 7.71333788887187 | 8.827468112520654 |
| 7 | 7 | 2008000270 | 2015-01-15 | 291,850.0 | 3 | 1.5 | 1060 | 9711 | 1.0 | 0.0 | 0.0 | 3 | 7 | 1060 | 0.0 | 1963 | 0.0 | 98198 | 47.4095 | -122.315 | 1650 | 9711 | Seattle | 1 | 0 | 0 | 0 | 1 | 0 | 6.966024187106112 | 9.181014542594355 | 6.966024187106112 | 7.408530566894625 | 9.181014542594355 |
| 8 | 8 | 2414600126 | 2015-04-15 | 229,500.0 | 3 | 1.0 | 1780 | 7470 | 1.0 | 0.0 | 0.0 | 3 | 7 | 1050 | 730.0 | 1960 | 0.0 | 98146 | 47.5123 | -122.337 | 1780 | 8113 | Seattle | 1 | 0 | 0 | 0 | 0 | 1 | 7.48436864328613 | 8.918650278126863 | 6.956545443151568 | 7.48436864328613 | 9.001222992395064 |
| 9 | 9 | 3793500160 | 2015-03-12 | 323,000.0 | 3 | 2.5 | 1890 | 6560 | 2.0 | 0.0 | 0.0 | 3 | 7 | 1890 | 0.0 | 2003 | 0.0 | 98038 | 47.3684 | -122.031 | 2390 | 7570 | Maple Valley | 1 | 0 | 0 | 0 | 1 | 0 | 7.544332108053688 | 8.788745881938134 | 7.544332108053688 | 7.779048644925556 | 8.931948346431493 |
Last rows
| Unnamed: 0 | id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | city | livable | q2_2014 | q3_2014 | q4_2014 | q1_2015 | q2_2015 | log_sqft_living | log_sqft_lot | log_sqft_above | log_sqft_living15 | log_sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21583 | 21587 | 7852140040 | 2014-08-25 | 507,250.0 | 3 | 2.5 | 2270 | 5536 | 2.0 | 0.0 | 0.0 | 3 | 8 | 2270 | 0.0 | 2003 | 0.0 | 98065 | 47.5389 | -121.881 | 2270 | 5731 | Snoqualmie | 1 | 0 | 1 | 0 | 0 | 0 | 7.727535110475447 | 8.619027497297505 | 7.727535110475447 | 7.727535110475447 | 8.653645314551737 |
| 21584 | 21588 | 9834201367 | 2015-01-26 | 429,000.0 | 3 | 2.0 | 1490 | 1126 | 3.0 | 0.0 | 0.0 | 3 | 8 | 1490 | 0.0 | 2014 | 0.0 | 98144 | 47.5699 | -122.288 | 1400 | 1230 | Seattle | 1 | 0 | 0 | 0 | 1 | 0 | 7.306531398939504 | 7.026426808699637 | 7.306531398939504 | 7.244227515603349 | 7.114769448366463 |
| 21585 | 21589 | 3448900210 | 2014-10-14 | 610,685.0 | 4 | 2.5 | 2520 | 6023 | 2.0 | 0.0 | 0.0 | 3 | 9 | 2520 | 0.0 | 2014 | 0.0 | 98056 | 47.5137 | -122.167 | 2520 | 6023 | Renton | 1 | 0 | 0 | 1 | 0 | 0 | 7.832014180505469 | 8.703340753043719 | 7.832014180505469 | 7.832014180505469 | 8.703340753043719 |
| 21586 | 21590 | 7936000429 | 2015-03-26 | 1,010,000.0 | 4 | 3.5 | 3510 | 7200 | 2.0 | 0.0 | 0.0 | 3 | 9 | 2600 | 910.0 | 2009 | 0.0 | 98136 | 47.5537 | -122.398 | 2050 | 6200 | Seattle | 1 | 0 | 0 | 0 | 1 | 0 | 8.163371316459912 | 8.881836305004146 | 7.863266724009573 | 7.625595072132453 | 8.732304571033183 |
| 21587 | 21591 | 2997800021 | 2015-02-19 | 475,000.0 | 3 | 2.5 | 1310 | 1294 | 2.0 | 0.0 | 0.0 | 3 | 8 | 1180 | 130.0 | 2008 | 0.0 | 98116 | 47.5773 | -122.409 | 1330 | 1265 | Seattle | 1 | 0 | 0 | 0 | 1 | 0 | 7.177782416195197 | 7.1654934750608446 | 7.073269717459709 | 7.1929342212158 | 7.142827401161621 |
| 21588 | 21592 | 263000018 | 2014-05-21 | 360,000.0 | 3 | 2.5 | 1530 | 1131 | 3.0 | 0.0 | 0.0 | 3 | 8 | 1530 | 0.0 | 2009 | 0.0 | 98103 | 47.6993 | -122.346 | 1530 | 1509 | Seattle | 1 | 1 | 0 | 0 | 0 | 0 | 7.333023014386481 | 7.030857476116121 | 7.333023014386481 | 7.333023014386481 | 7.319202458767849 |
| 21589 | 21593 | 6600060120 | 2015-02-23 | 400,000.0 | 4 | 2.5 | 2310 | 5813 | 2.0 | 0.0 | 0.0 | 3 | 8 | 2310 | 0.0 | 2014 | 0.0 | 98146 | 47.5107 | -122.362 | 1830 | 7200 | Seattle | 1 | 0 | 0 | 0 | 1 | 0 | 7.745002803515838 | 8.667852067701348 | 7.745002803515838 | 7.512071245835466 | 8.881836305004146 |
| 21590 | 21594 | 1523300141 | 2014-06-23 | 402,101.0 | 2 | 0.75 | 1020 | 1350 | 2.0 | 0.0 | 0.0 | 3 | 7 | 1020 | 0.0 | 2009 | 0.0 | 98144 | 47.5944 | -122.299 | 1020 | 2007 | Seattle | 1 | 1 | 0 | 0 | 0 | 0 | 6.927557906278317 | 7.2078598714324755 | 6.927557906278317 | 6.927557906278317 | 7.604396348796338 |
| 21591 | 21595 | 291310100 | 2015-01-16 | 400,000.0 | 3 | 2.5 | 1600 | 2388 | 2.0 | 0.0 | 0.0 | 3 | 8 | 1600 | 0.0 | 2004 | 0.0 | 98027 | 47.5345 | -122.069 | 1410 | 1287 | Issaquah | 1 | 0 | 0 | 0 | 1 | 0 | 7.377758908227872 | 7.778211474512492 | 7.377758908227872 | 7.2513449833722134 | 7.160069207596128 |
| 21592 | 21596 | 1523300157 | 2014-10-15 | 325,000.0 | 2 | 0.75 | 1020 | 1076 | 2.0 | 0.0 | 0.0 | 3 | 7 | 1020 | 0.0 | 2008 | 0.0 | 98144 | 47.5941 | -122.299 | 1020 | 1357 | Seattle | 1 | 0 | 0 | 1 | 0 | 0 | 6.927557906278317 | 6.98100574072173 | 6.927557906278317 | 6.927557906278317 | 7.2130316598348685 |